Anjanesh Vaidya · Smartsheet Developer · ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	16

About Me

About Me

Country	India
Title	Smartsheet Developer
Area of Expertise	Workflow Automation, Reporting and Analytics, Dashboard Creation, Form Design, Integrations, Data Shuttle, Data Mesh, Data Table, Dynamic view, Control Centre.
About Me	I am passionate about helping individuals and businesses unlock the full potential of Smartsheet to streamline and automate their workflows. With extensive experience in customizing Smartsheet solutions, I facilitate users in transforming their processes for greater efficiency and productivity. My expertise lies in leveraging the robust capabilities of Smartsheet to create tailored solutions that meet unique needs. Whether you're looking to improve project management, enhance team collaboration, or automate repetitive tasks.
Linkedin	https://www.linkedin.com/in/anjaneshvaidya

Analytics

52

Posts

369

Visits

486

Points

Jul 10, 2023

Join Date

Aug 2, 2024

Last Active

Reactions

• Insightful 1

  1
• Vote Up 4

  4
• Awesome 15

  15

• Activity
• Discussions1
• Comments51

• Re: Why is my VLOOKUP not working?

  Anjanesh Vaidya

  03/06/24
  Hi David Brandt, You can try the following formula- =VLOOKUP([ANALYST PARTICIPANTS]@row, {SAFFS:Firm:Analyst}, 2, false) Here, I have removed a colon in the lookup table selection. So, you can again …
  1 ·

• Re: Number of days between 2 dates ignoring errors

  Anjanesh Vaidya

  01/16/24
  Hi Eenmeier, You can try following formula in the sheet summary. =AVERAGEIF([Live Date]:[Live Date], AND(MONTH(@cell) = 1, YEAR(@cell) = 2024), [Dates to live]:[Dates to live]) You can specify the ye…
  2 ·

• Re: Formula Help Calculate # of Days with 2 date fields, unless date field is blank use todays date.

  Anjanesh Vaidya

  10/04/23
  Hi Danielle Maroon, You can try the below formula- =IF(AND(NOT(ISBLANK([Build Start Date]@row)), NOT(ISBLANK([Build End Date]@row))), [Build End Date]@row - [Build Start Date]@row, IF(ISBLANK([Build …
  1 ·

• Re: Formula HELP... Display number only is formula results in less than ZERO

  Anjanesh Vaidya

  10/04/23
  Hi Danielle Maroon, Please use the below mentioned logic as per your cells. here, I have used IF condition, so if # of Contracted eDocs - # of Submitted eDocs< 0 then it will show blank otherwise …
  1 ·

• Re: Automated DOTs byt date, Need Checkbox TRUE to equeal Green Dot

  Anjanesh Vaidya

  10/03/23
  Hi Thomas Reilly, You mean that, you want to add one more condition in the existing formula, right? That is if checkbox is checked than status to turn green. Please let me know so I can provide a for…
  1 ·

Previous